update ACT_GE_PROPERTY set VALUE_ = '7.1.0.0' where NAME_ = 'common.schema.version';

update ACT_GE_PROPERTY set VALUE_ = '7.1.0.0' where NAME_ = 'entitylink.schema.version';

update ACT_GE_PROPERTY set VALUE_ = '7.1.0.0' where NAME_ = 'identitylink.schema.version';

update ACT_GE_PROPERTY set VALUE_ = '7.1.0.0' where NAME_ = 'job.schema.version';

update ACT_GE_PROPERTY set VALUE_ = '7.1.0.0' where NAME_ = 'batch.schema.version';

create index ACT_IDX_ACT_HI_TSK_LOG_TASK on ACT_HI_TSK_LOG(TASK_ID_);

update ACT_GE_PROPERTY set VALUE_ = '7.1.0.0' where NAME_ = 'task.schema.version';

update ACT_GE_PROPERTY set VALUE_ = '7.1.0.0' where NAME_ = 'variable.schema.version';

update ACT_GE_PROPERTY set VALUE_ = '7.1.0.0' where NAME_ = 'eventsubscription.schema.version';

UPDATE FLW_EV_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;


UPDATE FLW_EV_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

update ACT_GE_PROPERTY set VALUE_ = '7.1.0.0' where NAME_ = 'schema.version';

UPDATE ACT_CMMN_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;


UPDATE ACT_CMMN_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE ACT_DMN_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;


UPDATE ACT_DMN_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

